package com.koron.configure.changeshift.mapper;

import com.koron.configure.changeshift.bean.ChangeShiftCFBean;
import com.koron.configure.changeshift.bean.ChangeShiftCFDto;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ChangeShiftCFMapper {

    int deleteByPrimaryKey(String id);

    int insert(ChangeShiftCFBean record);

    int insertOrUpdate(ChangeShiftCFBean record);

    int insertOrUpdateSelective(ChangeShiftCFBean record);

    int insertSelective(ChangeShiftCFBean record);

    ChangeShiftCFBean selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(ChangeShiftCFBean record);

    int updateByPrimaryKey(ChangeShiftCFBean record);

    //检查一级项重复
    List<String> queryAllByFirstLevelGroupBy(@Param("id") String id);

    //交接班列表接口
    List<ChangeShiftCFDto> queryAllByDeptIdAndDeptNameAndLocationAndLocationName(ChangeShiftCFDto dto);

    //查询一级项目个数
    List<String> countByFirstLevelGroup();

    //查询一级项下二级项个数
    Integer countByFirstLevel(@Param("firstLevel")String firstLevel);


}
